sdk/samples/all in on code/Visual Studio 2010/VBAzureBingMaps/DAL/UpdateTravel.sql

   1 CREATE PROCEDURE [dbo].[UpdateTravel]
   2         @PartitionKey nvarchar(200),
   3     @RowKey  uniqueidentifier,
   4     @Place NVarchar(200),
   5     @GeoLocation NVarchar(max),
   6     @Time datetime
   7 AS
   8 BEGIN
   9       Update [dbo].[Travel]
  10       Set [Place] = @Place,
  11       [GeoLocation] = Geography::STGeomFromText(@GeoLocation, 4326),
  12       [Time] = @Time
  13     Where PartitionKey = @PartitionKey AND RowKey = @RowKey
  14 END